home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vtrips.sql < prev    next >
Text File  |  2000-05-12  |  349b  |  15 lines
  1. CREATE OR REPLACE VIEW vtrips AS SELECT 
  2.   TRIPS.ROUTEID, TRIPS.RUNID, TRIPS.ID, 
  3.   TRIPS.DEP_TIME, TRIPS.DIRECTION1, 
  4.   TRIPS.DIRECTION2, TRIPS.MILEAGE,
  5.   TRIPS.CONFIG_NUM, DAY.DESCR
  6. FROM 
  7.   TRIPS TRIPS, 
  8.   RUNS RUNS, 
  9.   DAYOFWEEK DAY
  10. WHERE 
  11. ( TRIPS.RUNID=RUNS.ID ) AND 
  12.   ( TRIPS.ROUTEID=RUNS.ROUTEID ) AND 
  13.   ( RUNS.DAY=DAY.NUM );
  14.  
  15.